/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : localhost:3306
 Source Schema         : reservation

 Target Server Type    : MySQL
 Target Server Version : 50723
 File Encoding         : 65001

 Date: 17/08/2021 12:57:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for reservation_record
-- ----------------------------
DROP TABLE IF EXISTS `reservation_record`;
CREATE TABLE `reservation_record` (
  `r_id` int(11) NOT NULL AUTO_INCREMENT,
  `reservation_date` datetime NOT NULL,
  `needle_num` int(11) NOT NULL,
  `period` varchar(20) NOT NULL,
  `vaccine_brand` varchar(20) NOT NULL,
  `address` varchar(200) NOT NULL,
  `detailed` varchar(200) NOT NULL,
  `u_id` int(11) DEFAULT NULL,
  `r_status` int(11) NOT NULL,
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of reservation_record
-- ----------------------------
BEGIN;
INSERT INTO `reservation_record` VALUES (1, '2021-06-01 00:00:00', 1, '7:30-8:00', '北京生物', '横琴新区（横琴镇）社区卫生服务中心', '横琴新区宝兴路118号7号楼', 2, 2);
INSERT INTO `reservation_record` VALUES (2, '2021-06-22 00:00:00', 2, '7:30-8:00', '北京生物', '横琴新区（横琴镇）社区卫生服务中心', '横琴新区宝兴路118号7号楼', 2, 3);
INSERT INTO `reservation_record` VALUES (3, '2021-07-01 00:00:00', 1, '7:30-8:00', '北京生物', '横琴新区（横琴镇）社区卫生服务中心', '横琴新区宝兴路118号7号楼', 3, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
